***   Need STATA 13 or above for this to work  ***
***import importable data and save as .dta files***
cd "Z:\Econ428_Sp15\Working_Wang"

forval yr = 2003/2010 {
forval i = 1/7 {
clear all
cap import excel using "importable data/`yr' import/`yr'_`i'_import.xlsx", first clear
cap destring _all, replace
cap tostring city_id, replace
cap saveold "`yr'_`i'.dta", replace
}
}
